Data Wrangling with SQL by Raghav Kandarpa | Shivangi Saxena

Author:Raghav Kandarpa | Shivangi Saxena
Language: eng
Format: epub
Publisher: Packt Publishing Pvt Ltd
Published: 2023-07-30T00:00:00+00:00

Using subqueries in SELECT statements

A subquery can be used in a SELECT statement to return data that will be used as a condition in the main query. The subquery runs first and returns a result set, which is then used by the main query to retrieve data.

The subquery can be placed in the SELECT clause to return a single value.

For example, a subquery in the SELECT clause could be used to calculate the average of a set of values and return it as a single value in the main query.

Example 1 – subquery in the SELECT clause

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.